Setting Up Oracle User Privileges
Rights for Registering Features:
-
Role — Connect, Resource
-
System — Create View (if creating topology objects and tables) Unlimited tablespace (optional)
-
Object — Grant the following privileges on the LIVE or other Oracle workspaces to extract from or commit to: ACCESS_WORKSPACE, CREATE_WORKSPACE, MERGE_WORKSPACE, REMOVE_WORSPACE
Rights for Intent to View Only:
-
Role — Connect, Resource
-
Object — Grant the following privileges on the LIVE or other Oracle workspaces to extract from or commit to: ACCESS_WORKSPACE, CREATE_WORKSPACE, MERGE_WORKSPACE, REMOVE_WORSPACE
Rights for Extract/Modify/Post and Post Only Workflows:
-
Role — Connect, Resource
-
Object — Grant the following privileges on the LIVE or other Oracle workspaces to extract from or commit to: ACCESS_WORKSPACE, CREATE